<?php

class JobeetCategoryTable extends Doctrine_Table {
	/**
	 * Returns an instance of this class.
	 *
	 * @return object JobeetCategoryTable
	 */
	public static function getInstance() {
		return Doctrine_Core::getTable('JobeetCategory');
	}

	public function getWithJobs() {
		$q = $this -> createQuery('c') -> leftJoin('c.JobeetJobs j') -> where('j.expires_at > ?', date('Y-m-d H:i:s', time()));

		$q -> andWhere('j.is_activated = ?', 1);

		return $q -> execute();
	}

}
